[dbo].[BAEFieldDesignGetAllBySectionName]
create procedure [dbo].[BAEFieldDesignGetAllBySectionName] @SectionName as
varchar(30)
AS
SELECT *
FROM FieldDesign, FieldDesignSectionLookup, FieldSection
WHERE FieldDesign.TableName = FieldDesignSectionLookup.TableName AND FieldDesign.FieldName = FieldDesignSectionLookup.FieldName AND FieldDesignSectionLookup.FieldSectionId = FieldSection.FieldSectionId AND FieldSection.SectionName = @SectionName
ORDER BY FieldDesignSectionLookup.SortOrder asc
GO
